| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
R.A.G.E
   |
Posted - 2011.04.04 08:46:00 -
[1]
 Originally by: Varitina
I'm just going to give up on this, I don't know why in hell it keeps timing out, but its hopeless at this point.
Ok I have been watching this problem, try this, set up a TS3 server on a local machine using the mysql tables on your host, once you have it set up make sure to add your hosts ip and your actual ip not local machine to the whitelist,
once you have done that install this application on your host and add the sql table to your TS3 sql on your host.
when you first start TS3 it will generate the serverquery admin for you with a password.
use this on the config >> serveradmin and what ever the password is. this does work and works well.
if this works then you will know there is a issue with the TS3 server you are having hosted.
Very Nice application well done
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
R.A.G.E
|
Posted - 2011.04.06 17:34:00 -
[2]
Originally by: Varitina
Okay Mediek, I'll try this. Give me a day or two, really busy this week, and I'm not the best at local sql. I've done it a few times, but ill need to refresh.
I'll post when i have tried. I like this idea though.
If you have a problem look for me in game ill help you set it up :-) if i can co's ime rusty as well now
lol but i can assure you this really does work and it works well
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
R.A.G.E
|
Posted - 2011.04.10 17:15:00 -
[3]
Edited by: Mediek Ordos on 10/04/2011 17:27:58
Edited by: Mediek Ordos on 10/04/2011 17:18:32
Originally by: Jetro Grissom
Heya
Nice scripting but i have problems with using it.
Maybe i'm stupid, solution alway simple as we know.
I'm enterring whole data to config file as putted in readme.
Then i'm connecting to TS server as -MDD- Jetro Grissom (as showed in readme) and going to registration page.
Enterring limited api data and character name without corp ticker and press reigter.
I'm getting this message in reply:
Quote:
API Connection was established.
Checking...
Character: Jetro Grissom
Debug: User ID: 6XXXXX
Debug: API Key: XXXXXXXXXXXXXX
Character ID: XXXXXXXX
Debug: Character List:
Debug: Jetro Grissom
Debug: API verified.
You are not allowed to register on this server.
So how to fix it?
Ok How to fix, make sure you have your Corp and alliance names added to the whitelist that should rectify the problem in your case as you are in an alliance just add your alliance name in both.
// API Connection Testing Information (REQUIRED) - TESTID and TESTname MUST be the characterID and characterName of the SAME character respectively
public $TESTID = 00000000; <<<<<<<<<<<<<replace with your char id no
public $TESTname = "Jetro Grissom";
// Your alliance/corp name
public $ourname = "Massive Dynamic Alliance";
// Alliance Whitelist Information (REQUIRED) - Example: ("Alliance1","Alliance 2");
public $allyList = array("Massive Dynamic Alliance");
// Corporation Whitelist Information (REQUIRED) - Example: ("Corporation1","Corporation 2");
public $corpList = array("");
ok once config set up like this when you register do not use your Alliance tikker only your corp tikker on teamspeak server, no brackets
example A-C-E Mediek Ordos
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
R.A.G.E
|
Posted - 2011.04.10 18:21:00 -
[4]
Edited by: Mediek Ordos on 10/04/2011 18:26:56
Originally by: Jetro Grissom
well now it looks better, but now i'm getting same error as few posts above and don't know how to fix it.
Removing your old registrations...
0 old registrations removed.
An error occured: invalid URI supplied [F10]
I've restarted my TS server and it didn't helped.
[F10] = Failed to connect to your Teamspeak 3 server, ensure your details are correct (see $tsname in "Config Guide" to set up a ServerQuery user). If your details are certainly right, check with your host that they have ServerQuery enabled and haven't arsed about with the settings. If everything is in order make sure your webserver is on the Teamspeaks whitelist (see "Teamspeak Whitelist").
add your host ip where you are running the app from into your whitelist on your teamspeak server, if you are running your TS3 server on local machine add the actual ip not your local machine ip to whitelist as well, that done make sure if you are running on local machine to set the ports on your router and firewall.
also on the config, did you add the correct serveradmin query name and password that was created and you saved when you first started your server.
class Config {
// Administrators character
public $admin = "Mediek Ordos";
// Teamspeak 3 Server Query Information (REQUIRED)
public $tshost = "put ts3 host ip here";
public $tsname = "serveradmin";
public $tspass = "put serveradmin pass here";
public $tsport = "10011"; //ServerQuery Port
public $tscport = "9987"; //TeamSpeak client port
if not convo me in game
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
R.A.G.E
|
Posted - 2011.04.11 16:50:00 -
[5]
Originally by: Jetro Grissom
wow now it works
the error was in tsname
now its perfect ;-)
that is why i posted an example for you to look at it, glad you got it working ok.
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
R.A.G.E
|
Posted - 2011.04.12 11:43:00 -
[6]
Originally by: MJ Maverick
Update: v1.2
Security bot now optional to make sure people have the correct name. If you changed register.php to have "TICKER | NAME" then don't worry. The bot will know about you putting the | in and shouldn't go on a kicking spree if you did it properly.
General code tweaks made.
Readme updated.
If you changed register.php to have "TICKER | NAME" <<< would this be here line 192// SET NICKNAME
$nickname = $corpTicker." ".$character;
// TRY TO CONNECT - GATHER DETAILS - GRANT PERMISSIONS - STORE DETAILS
and like this ? $nickname = $corpTicker."| A-C-E | ".$character; ? co's i am thick when it comes to php :-)
ps only to glad to help peeps
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
R.A.G.E
|
Posted - 2011.04.12 21:20:00 -
[7]
Originally by: MJ Maverick
Originally by: Mediek Ordos
If you changed register.php to have "TICKER | NAME" <<< would this be here line 192// SET NICKNAME
$nickname = $corpTicker." ".$character;
// TRY TO CONNECT - GATHER DETAILS - GRANT PERMISSIONS - STORE DETAILS
and like this ? $nickname = $corpTicker."| A-C-E | ".$character; ? co's i am thick when it comes to php :-)
ps only to glad to help peeps
Hehe, no worries.
If you want "ACE | Mediek Ordos" then edit $nickname to:
[Line 193]
$nickname = $corpTicker." | ".$character;
[Line 247]
if ($alliancemate == true) {
$nickname = $corpTicker." | ".$character;
} else {
$nickname = $allianceTicker." | ".$corpTicker." | ".$character;
}
ok nearly :-)
If you want "ACE | Mediek Ordos" then edit $nickname to:
I want to do this "| ACE | Mediek Ordos" then edit $nickname to:
or " RAGE | ACE | Mediek Ordos" then edit $nickname to:
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
R.A.G.E
|
Posted - 2011.04.12 22:32:00 -
[8]
Originally by: MJ Maverick
Originally by: Mediek Ordos
ok nearly :-)
If you want "ACE | Mediek Ordos" then edit $nickname to:
I want to do this "| ACE | Mediek Ordos" then edit $nickname to:
or " RAGE | ACE | Mediek Ordos" then edit $nickname to:
[Line 193]
$nickname = "| ".$corpTicker." | ".$character;
[Line 247]
if ($alliancemate == true) {
$nickname = "| ".$corpTicker." | ".$character;
} else {
$nickname = $allianceTicker." | ".$corpTicker." | ".$character;
}
Will produce:
| ACE | Mediek Ordos
and
RAGE | ACE | Mediek Ordos
Already experimenting :-), ill try not to break it to much cheers MJ 
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
R.A.G.E
|
Posted - 2011.04.15 03:39:00 -
[9]
Edited by: Mediek Ordos on 15/04/2011 03:41:16
Edited by: Mediek Ordos on 15/04/2011 03:40:10
Originally by: Dutch Psycho00
i installed it on my server but when i enter my info i keep getting the following error :
API does not match the character you entered's account, make sure you have pasted your API details without any spaces either side and entered your characters name properly
here is the list of the debug mode for security reasons fragile info has been cleared
Debug: Running: Teamspeak 3 PHP Framework version: 1.1.5-beta
API Connection was established.
Checking...
Character: -----
Debug: User ID: ----------
Debug: API Key: -----------------------
Character ID: 0
Debug: Character List:
Debug: Dutch Psycho00
Debug: ------------
Debug: ---------------
Error: API does not match the character you entered's account, make sure you have pasted your API details without any spaces either side and entered your characters name properly. (Denied.)
anybody has any idea what this could be?
please let me know.
on the web registration do not use your corp/alliance tikker.
on the TS3 server make sure you DO USE corp/alliance tikker
works just fine
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
R.A.G.E
|
Posted - 2011.04.15 18:24:00 -
[10]
Originally by: Moogless
Edited by: Moogless on 15/04/2011 16:26:46
Originally by: Dutch Psycho00
Edited by: Dutch Psycho00 on 15/04/2011 16:23:24
followed your guide now i get this :S
Debug: Running: Teamspeak 3 PHP Framework version: 1.1.5-beta
API Connection was established.
Checking...
Character: Dutch Psycho00
Debug: User ID: *********
Debug: API Key: *********
Character ID: 1860253443
Debug: Character List:
Debug: Dutch Psycho00
Debug: *********
Debug: **************
Debug: API verified.
You are not allowed to register on this server.
Query aint being allowed to communicate with server.
Add Teamspeak 3 server to the firewall on the hostee, and on the webserver you have add the ip of the ts3 server to whitelist.
do you have the correct server query admin name and password for serverquery admin correct ??
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
R.A.G.E
|
Posted - 2011.04.16 05:17:00 -
[11]
Hi MJ, Have noticed the version.php on 1.2 is still 0.17
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
R.A.G.E
|
Posted - 2011.04.17 06:36:00 -
[12]
Originally by: MJ Maverick
Hmm, try again. I just checked the files I uploaded and it's saying 1.2 :/ Perhaps it didn't upload properly the first time.
Hi MJ, downloaded from link again and recievied a 1kb zip of nothing this time lol,checked the other zips and they are 0.17 versions.php.
cheers Mediek
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
R.A.G.E
|
Posted - 2011.04.17 18:07:00 -
[13]
Cheers MJ, have new zip and installed I would like to see this progess to having a staged
registration proccess as we discussed on TS a few weeks back, that being said did the alterations to register.php to include correct tikker tags in correct place for alliance & corp
A-C-E TS3REG by Maverick with viewer by Psychokiller
So you can see it working as an example other than MJ's fine work.
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
R.A.G.E
|
Posted - 2011.04.22 10:17:00 -
[14]
Originally by: Kari Trace
I've run a bit of a problem. Got everything installed , database is in, get my character data together and submit it...and then I get the following error:
Debug: Running: Teamspeak 3 PHP Framework version: 1.1.5-beta
API Connection was established.
Checking...
Character: -XMP- Kari Trace
Debug: User ID: *****REMOVED*****
Debug: API Key: *****REMOVED*****
Character ID: 0
An error occured: API server couldn't retrieve your account or the API wasn't correct, check for spaces after your entered API. (Error: Invalid username and/or password passed to UserData.LoginWebUser().) [126]
Using the same API data to call the API server directly gets me all the data I could ask for. But when coming from EVEOTS my account shows authentication failed (obviously).
Ideas?
ok firstly is your config set up correctly for TS3 server admin ?
example >> class Config {
// Administrators character
public $admin = "Mediek Ordos";
// Teamspeak 3 Server Query Information (REQUIRED)
public $tshost = "put ts3 host ip here";
public $tsname = "serveradmin";
public $tspass = "put serveradmin pass here";
public $tsport = "10011"; //ServerQuery Port
public $tscport = "9987"; //TeamSpeak client port
lets try this first, then in the config have you got the whitelist set up correctly ?
then when registering on the web interface use just use your char name no corp/ally tikker.
on temaspeak use your corp tikker and char name for me it is like this | A-C-E | Mediek Ordos.
hope this helps
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
R.A.G.E
|
Posted - 2011.04.22 21:08:00 -
[15]
Originally by: MJ Maverick
Kari, make sure you are registering correctly. Take a look at the readme on how to register.
Your name in Teamspeak should be exactly: "-XMP- Kari Trace"
Your Character Name on the registration page should be exactly: "Kari Trace"
API Error: 512 = Invalid charID passed to CharData.GetCharacter().
This is likely due to not entering your name into the "Character Name" box correctly.
Hope this helps bud.
Hm thought that was what I said but in the long routed way, :-)
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
R.A.G.E
|
Posted - 2011.04.23 07:57:00 -
[16]
Originally by: Kari Trace
Originally by: Mediek Ordos
Originally by: MJ Maverick
Kari, make sure you are registering correctly. Take a look at the readme on how to register.
Your name in Teamspeak should be exactly: "-XMP- Kari Trace"
Your Character Name on the registration page should be exactly: "Kari Trace"
API Error: 512 = Invalid charID passed to CharData.GetCharacter().
This is likely due to not entering your name into the "Character Name" box correctly.
Hope this helps bud.
Hm thought that was what I said but in the long routed way, :-)
Checked an double checked:
TS: Identity: -XMP- Kari Trace
Registration page: Kari Trace
Debug: User ID: *****REMOVED*****
Debug: API Key: *****REMOVED*****
Character ID: *****REMOVED*****
An error occured: API server couldn't retrieve your account or the API wasn't correct, check for spaces after your entered API. (Error: Invalid username and/or password passed to UserData.LoginWebUser().) [126]
Sorry to be a pain on this. I know it `should` work without much issue...
Mediek Ordos: you have EVEmail.
KT
Read and replied to Eve Mail, Convo me in game when you are online so i can set up access for you on our TS and we can run a few experiments on the registration from there if you are up for it, looking so far it just seems you are having a API issue, but we will try to iron out the issue for you on comms, look forward to speaking to you.
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
R.A.G.E
|
Posted - 2011.04.23 22:31:00 -
[17]
Originally by: MJ Maverick
That's certainly some anomaly you have their KAri. I've done a bit of research and it seems to be something some users get and its definitely the API server not EVEOTS.
Have you tried creating a new Limited API Key? Perhaps that might snap the server out of it.
Hi MJ, I have been helping set this up today and have nearly got there, what i have done is set this up on my server with the correct blue group set to a created group on the TS3 server, on A-C-E's current set up Kari Trace is now able to register with the correct corp tikker and the blue group in config set to one I have created.
Soooo, I have now set it up on our server pointing to Kari's TS3 server >> api working fine but Kari now has to set the query ip_whirelist correctly in TS3 server config, allow that IP to have remote access to his MySql server and open up the ports on his router for the server query admin, once he has done this I am sure it will work ok.
Once we have it working I will the transfer it to Kari's server and see if it works ok on his server, will update progress as we go along, the issue is not script side it is server side :-)
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
R.A.G.E
|
Posted - 2011.04.25 17:43:00 -
[18]
Edited by: Mediek Ordos on 25/04/2011 17:44:56
Originally by: MJ Maverick
Great, thanks again Mediak. Have you checked if Kari had the groups set right on his server?
ok :-) here is what i did, initialy caused some head scratching as on first set and trial it refused to register Kari due to the char already having permissions on TS3 server,so I went to the config of eveots and sure enough the config was set to server group guest "8" so i changed it to one I created on TS3 server called registerd and adjusted the eveots config for blue corps group to match the new TS3 group number.
IE.// Teamspeak 3 group for alliance/corp members
public $group = 9;
// Teamspeak 3 group for people on the whitelist but not in your alliance/corp
public $bluegroup = 10; <<<<<<<<<<<<<<<< CHANGED THIS FROM GUEST GROUP 8
// Banner Image
public $banner = "images/banner.jpg";
Script then ran through fine on my server just waiting for Kari to alter his server now to run test n his setup, :-)
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
R.A.G.E
|
Posted - 2011.04.25 17:46:00 -
[19]
Originally by: Father O'Malley
i have dubbel check the sql tabel is added i am going to try another char
Father do you require some Divine intervention as well, lol, :-)
A-C-E
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
R.A.G.E
|
Posted - 2011.04.25 18:04:00 -
[20]
Originally by: Father O'Malley
yes
lol
oK ill find you in game m8ty
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
Imperial 0rder
|
Posted - 2011.08.30 05:11:00 -
[21]
Originally by: MillerUk
Edited by: MillerUk on 29/08/2011 18:02:44
Nice work MJ!
Altered the admin system to fit my needs and removed the need to login based on previous sessions made from website so i dont have to use mutiple logins
Also added option to list all registered members and their TS id, can also edit a member (usefull if they change corp so i can change the ticker without having to use database editing)
Nice, and usefull, are you going to share your adjustments ?
Ill drop you admin link later MJ, we alterd the templates again :-) worked sweet as a nut again nice one m8ty :-)
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
Imperial 0rder
|
Posted - 2011.08.30 18:39:00 -
[22]
Originally by: C'Thul
Originally by: MillerUk
Originally by: C'Thul
what does this system even do? TS3 has no user-registration anymore, instead unique IDs are used ... so judging from your description this system doesnt do anything 
If you knew anything about the Teamspeak user groups and IDs you would t bother asking that question
in fact, as a professional software-developer and gamer who uses TS3 a lot i know a bit about TS3, i already wrote SQuery-software, kiddo ... now : shut and and let the adults talk, mkay? Troll elsewhere please.
It is nice that proffesional software developers get involved with these projects, C'Thul take a look at the scripting MJ has written in its entirety then you will see what it is actually doing by assigning server groups with id keys 
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
Mediek Ordos
Caldari
Association of Commonwealth Enterprises
Imperial 0rder
|
Posted - 2011.08.30 20:15:00 -
[23]
nice one MillierUK
i couldnt get the database id working so i changed it a bit
from line 377 to line 439 admin_panel.php
break;
case "auditmembers":
// Authorised to access this area?
// Connect to server and select database.
SQLconnect(open);
$query = mysql_query("SELECT securityLevel FROM admins WHERE username = \"".$_SESSION['character']."\";");
while ($row = mysql_fetch_array($query)) {
$securityLevel = "$row[securityLevel]";
}
SQLconnect(close);
// Audit Members List
?>
<?php
// Connect to server and select database.
SQLconnect(open);
// Set query
$query = mysql_query("SELECT * FROM users ORDER BY tsName;");
// Build admin table
echo "<table width=\"100%\" border=\"0\">";
echo "<tr><td width=\"32px\"></td><td>Teamspeak Name</td><td align=\"center\">Corp</td><td width=\"100px\">Database Id</td><td width=\"40px\"></td></tr>";
// Populate admin table
while ($row = mysql_fetch_array($query)) {
$id = "$row[entryID]";
$tsID = "$row[tsUniqueID]";
$characterID = "$row[characterID]";
$username = "$row[tsName]";
$tsDatabaseID = "$row[tsDatabaseID]";
// Get the characters current corporation
if ($characterID !== "") {
try {
$fetch = $pheal->eveScope->CharacterInfo(array('characterID' => $characterID));
$fetchCorporation = $fetch->corporation;
$fetchAlliance = $fetch->alliance;
} catch (PhealException $e) {
die("An error occured: ".$e->getMessage()." [A".__LINE__."]");
}
}
if ($id == $c->adminID) {
echo "<tr class=\"listRootAdmin\">";
} else {
echo "<tr>";
}
echo "<td width=\"32px\">";
if ($characterID !== "") {
echo "<img src=\"http://image.eveonline.com/Character/".$characterID."_32.jpg\" border=\"0\">";
} else {
echo "<img src=\"images/admin.png\" border=\"0\">";
}
echo "</td><td>".$username."<br><font size=1>".$tsID."</font></td><td align=\"center\">".$fetchCorporation."<br /><font size=\"2\">".$fetchAlliance."</font></td><td align=\"center\">".$tsDatabaseID."</td>";
if ($id == $c->adminID && $id == $_SESSION["EVEOTSid"]) {
echo "<td><a href=\"?menu=member_edit&id=".$id."\"><img src=\"images/edit.png\" border=\"0\" title=\"Edit\"></a></td></tr>";
} else if ($id == $c->adminID) {
echo "<td></td></tr>";
} else {
echo "<td><a href=\"?menu=member_edit&id=".$id."\"><img src=\"images/edit.png\" border=\"0\" title=\"Edit\"></a> <a href=\"?menu=delete_member&id=".$id."\" onclick=\"return confirm('Are you sure you want to delete ".$username."?')\"><img src=\"images/delete.png\" border=\"0\" title=\"Delete\"></a></td></tr>";
}
}
echo "</table>";
SQLconnect(close);
break;
case "add_admin";
now it works, edit and delete function need some attention nice one m8ty
http://www.a-c-e.eu/images/A-C-E-signature.jpg |
| |
|